TabUtils - version 1.0

All Examples are based around the MASTER.DBF Table supplied within the \Delphi\Demos\Data direcortory. An IDAPI Alias named DBDEMOS (set up by delphi upon installation) is required in order to use this demonstration.
Alternatively, the MASTER.DBF file(s) are supplied and you must then create an alias which points to the containing directory.

Below follows a brief description of each of the TabUtils functions.


Summary - GroupSummary
Select the required field(s) to sum up from the list box, and a field to group on from the drop down list. Pressing the GroupSummary button will summarise the selected information and output it to a new table. This can be seen in the DataGrid.

Summary - ColumnTotal
Select a field from the drop down list and press the ColumnTotal button. The sum of all values in this field will then be displayed.

Summary - DS SQL Column Total and DS Table Column Total
These buttons have the same function as the GroupSummary button but the underlying function gets the data from a dataset rather than a specific table. The two buttons associate an SQL scipt and a table with the dataset.
	
Statistical - Min, Max and Avg
Pressing these buttons will display the Min, Max or Average of the selected field.

Import/Export - Create from CSV
This will create a database table based on the contents of a comma separated file. The included example is called FROMCSV.TXT.

Import/Export - Append from CSV
This will add records to an existing table based on the contents of a comma separated file. The included FROMCSV.TXT file may be used here again.

Import/Export - Export to TXT
This button will export the contents of a table to an ascii text file in the format selected. Available formats are Fixed Width, Comma Separated and Quoted. When complete, you may view the text file by clicking the 'View It' button.

Import/Export - DataSet Export
This button will export the contents of a dataset to a comma separated ascii text file.

Other - GetFieldName
Use the spinner to select a field number and press the GetFieldName button. The tables' underlying fieldname will then be shown. Note that field numbers start at zero.

Function Usage.
The demo project includes examples of the TabUtils functions. A detailed description of variable types and returning values can be found in the usage.txt file.










Disclaimer of Warranty

THIS SOFTWARE AND THE ACCOMPANYING FILES ARE SOLD "AS IS" AND WITHOUT WARRANTIES AS TO PERFORMANCE OF MERCHANTABILITY OR ANY OTHER WARRANTIES WHETHER EXPRESSED OR IMPLIED. NO WARRANTY OF FITNESS FOR A PARTICULAR PURPOSE IS OFFERED.


_____________________________________________________________________



Ordering Information.

Please send me _ copies(s) of Version 1 of Table Utilities @ £15 each (£30 each includes source code). Delivery will be free by E-Mail. Otherwise please add £5 for postage.

Please make cheques payable to Key I.T. Systems Ltd.

I enclose a cheque for £_________.


Users may also register on Compuserve via the SWREG forum.

Name:
Address:



E-Mail:
Fax:
Phone:



Send to:-
Key IT Systems Ltd
Enterprise House
Carlton Road
Worksop
Notts
S81 7QF

Email - keyit@innotts.co.uk
Fax - 01909 489321